MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 235

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Object Date, Object Begin Date, Object End Date, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
1218 33.120.202 0 1 1315 American Decorative Arts 1 Candlestick 163 Candlestick American 1         Former Attribution 27 Formerly attributed to Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 ca. 1740–50 1735 1750 Silver 2 6 1/16 x 3 15/16 in. (15.4 x 10 cm); 9 oz. 6 dwt. (289.7 g) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
1219 33.120.203 0 1 1316 American Decorative Arts 1 Candlestick 163 Candlestick American 1         Lithographer 28 Formerly attributed to Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1740–50 1740 1750 Silver 2 6 1/8 x 4 in. (15.6 x 10.2 cm): 8 oz. 17 dwt. (274.6 g) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
1360 33.120.211a, b 0 1 1468 American Decorative Arts 1 Caster 183 Caster American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1740–50 1740 1750 Silver 2 Overall: 5 1/4 x 1 7/8 in. (13.3 x 4.8 cm); 3 oz. 18 dwt. (120.9 g) Body: H. 3 in. (7.6 cm); 2 oz. 11 dwt. (80 g) Cover: 2 9/16 in. (6.5 cm); 1 oz. 6 dwt. (40.9 g) Foot: Diam. 1 3/4 in. (4.4 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
2171 52.170a, b 0 1 2354 American Decorative Arts 1 Cup 107 Two-Handled Cup and Cover American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1735–40 1735 1741 Silver 2 Overall: 10 3/8 x 10 1/16 in. (26.4 x 25.6 cm); 41 oz. 14 dwt. (1296.9 g) Foot: Diam. 4 5/8 in. (11.7 cm) Lip: Diam. 5 15/16 in. (15.1 cm) Body: H. 6 3/4 in. (17.1 cm); 31 oz. 3 dwt. (968.7 g) Cover: 4 3/16 x 6 1/8 in. (10.6 x 15.6 cm); 10 oz. 11 dwt. (328.2 g) Morris K. Jesup Fund, 1952 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
2490 55.126 0 1 2683 American Decorative Arts 1 Cream pot 284 Creampot American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1735–45 1735 1745 Silver 2 Overall: 3 1/2 x 3 3/16 x 2 1/4 in. (8.9 x 8.1 x 5.7 cm); 3 oz. 8 dwt. (106 g) Foot: Diam. 2 in. (5.1 cm) Rogers Fund, 1955 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
4981 22.90 0 1 5345 American Decorative Arts 1 Cann 172 Cann American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 ca. 1745 1735 1750 Silver 2 Overall: 5 x 5 1/16 in. (12.7 x 12.9 cm); 10 oz. 14 dwt. (332.4 g) Lip: Diam. 3 3/16 in. (8.1 cm) Foot: Diam. 3 5/16 in. (8.4 cm) Rogers Fund, 1922 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
6294 53.195 0 1 6693 American Decorative Arts 1 Porringer 297 Porringer American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 ca. 1740 1735 1745 Silver 2 Overall: 1 13/16 x 8 1/8 in. (4.6 x 20.6 cm); 8 oz. 14 dwt. (270.1 g) Lip: Diam. 5 1/4 in. (13.3 cm) Body: Diam. 5 7/16 in. (13.8 cm) Anonymous Gift, in memory of Robert Gordon Butler, godson of Robert Gordon, a founder of The Metropolitan Museum of Art, 1953 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
6911 23.130.1 0 1 7377 American Decorative Arts 1 Spoon 78 Serving Spoon American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1730–40 1730 1740 Silver 2 2 1/16 x 16 5/16 x 3 in. (5.2 x 41.4 x 7.6 cm); 7 oz. 2 dwt. (220.2 g) Gift of Edward Robinson, 1923 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
7309 33.120.420 0 1 7789 American Decorative Arts 1 Spoon 78 Spoon American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1725–50 1725 1750 Silver 2 L. 7 5/8 in. (19.4 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
8170 43.75 0 1 8807 American Decorative Arts 1 Salt 300 Salt American 1         Maker 1   Jacob Hurd American, Boston, Massachusetts 1702/3–1758 Boston, Massachusetts   Hurd, Jacob 235 American 1 1702 1758 1730–40 1730 1740 Silver 2 1 1/4 x 2 3/4 x 2 7/16 in. (3.2 x 7 x 6.2 cm); 2 oz. 4 dwt. (68.9 g) Rogers Fund, 1943 Made in 1 Boston 8     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 125.38ms · Data license: CC0 · Data source: metmuseum/openaccess